SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspEmailTemplate_INSERT
(
@subject AS nvarchar(150) = null,
@content AS nvarchar(MAX) = null,
@templateType AS int = null,
@createDate AS datetime = null,
@lastModifiedDate AS datetime = null
)
AS

INSERT INTO
  [dbo].[EmailTemplate]
(
  [Subject],
  [Content],
  [TemplateType],
  [CreateDate],
  [LastModifiedDate]
)
VALUES
(
  @subject,
  @content,
  @templateType,
  @createDate,
  @lastModifiedDate
)

SELECT SCOPE_IDENTITY()

GO
